Select * From CuDtGeneric cg left outer join CuDtattach ca on cg.icuitem=ca.xiCuItem Where (ca.nfileName=N'{F029CE8B-6340-4D38-BF3E-B31923A6E9D2}' Or cg.ximgFile=N'{F029CE8B-6340-4D38-BF3E-B31923A6E9D2}' Or cg.fileDownLoad=N'{F029CE8B-6340-4D38-BF3E-B31923A6E9D2}') And fctupublic <> 'N' And ((cg.avBegin<>'' And cg.avEnd is NULL And getDate()>cg.avBegin ) Or (cg.avBegin is NULL And cg.avEnd<>'' And getDate() < cg.avEnd) Or (cg.avBegin<>'' And cg.avEnd<>'' And getDate() Between cg.avBegin And cg.avEnd) Or (cg.avBegin is NULL And cg.avEnd is NULL))
檔案未公開或已過期!